Truck data report

Dataset statistics

Number of variables	32
Number of observations	6880
Missing cells	25125
Missing cells (%)	11.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	256.0 B

Variable types

Categorical	8
Text	11
DateTime	2
Unsupported	7
Numeric	4

Alerts

`ontime` has constant value "G"	Constant
`delay` has constant value "R"	Constant
`Driver_MobileNo` is highly overall correlated with `Market/Regular`	High correlation
`Market/Regular` is highly overall correlated with `Driver_MobileNo` and 2 other fields	High correlation
`Minimum_kms_to_be_covered_in_a_day` is highly overall correlated with `Market/Regular` and 3 other fields	High correlation
`TRANSPORTATION_DISTANCE_IN_KM` is highly overall correlated with `customerID` and 1 other fields	High correlation
`customerID` is highly overall correlated with `Minimum_kms_to_be_covered_in_a_day` and 2 other fields	High correlation
`customerNameCode` is highly overall correlated with `Minimum_kms_to_be_covered_in_a_day` and 3 other fields	High correlation
`vehicleType` is highly overall correlated with `Market/Regular` and 2 other fields	High correlation
`GpsProvider` is highly imbalanced (59.4%)	Imbalance
`Market/Regular` is highly imbalanced (91.9%)	Imbalance
`Minimum_kms_to_be_covered_in_a_day` is highly imbalanced (67.1%)	Imbalance
`customerID` is highly imbalanced (54.2%)	Imbalance
`customerNameCode` is highly imbalanced (53.9%)	Imbalance
`GpsProvider` has 953 (13.9%) missing values	Missing
`Data_Ping_time` has 953 (13.9%) missing values	Missing
`Current_Location` has 964 (14.0%) missing values	Missing
`Curr_lat` has 953 (13.9%) missing values	Missing
`Curr_lon` has 953 (13.9%) missing values	Missing
`ontime` has 4332 (63.0%) missing values	Missing
`delay` has 2538 (36.9%) missing values	Missing
`trip_end_date` has 194 (2.8%) missing values	Missing
`TRANSPORTATION_DISTANCE_IN_KM` has 712 (10.3%) missing values	Missing
`vehicleType` has 828 (12.0%) missing values	Missing
`Minimum_kms_to_be_covered_in_a_day` has 4060 (59.0%) missing values	Missing
`Driver_Name` has 3429 (49.8%) missing values	Missing
`Driver_MobileNo` has 4189 (60.9%) missing values	Missing
`Planned_ETA` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`actual_eta` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`OriginLocation_Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DestinationLocation_Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`trip_start_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`trip_end_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`supplierID` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-08-12 22:37:03.834123
Analysis finished	2024-08-12 22:37:12.792083
Duration	8.96 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

GpsProvider
Categorical

IMBALANCE MISSING

Distinct	29
Distinct (%)	0.5%
Missing	953
Missing (%)	13.9%
Memory size	53.9 KiB

CONSENT TRACK	3859
VAMOSYS	788
EKTA	322
JTECH	241
MANUAL	219
Other values (24)	498

Length

Max length	22
Median length	13
Mean length	10.914122
Min length	4

Characters and Unicode

Total characters	64688
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	CONSENT TRACK
2nd row	VAMOSYS
3rd row	CONSENT TRACK
4th row	VAMOSYS
5th row	VAMOSYS

Common Values

Value	Count	Frequency (%)
CONSENT TRACK	3859	56.1%
VAMOSYS	788	11.5%
EKTA	322	4.7%
JTECH	241	3.5%
MANUAL	219	3.2%
KRC LOGISTICS	175	2.5%
WDSL	72	1.0%
BEECON	34	0.5%
NUEVASTECH	29	0.4%
Garuda	28	0.4%
Other values (19)	160	2.3%
(Missing)	953	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
consent	3859	38.5%
track	3859	38.5%
vamosys	788	7.9%
ekta	322	3.2%
jtech	241	2.4%
manual	219	2.2%
logistics	188	1.9%
krc	175	1.7%
wdsl	72	0.7%
beecon	34	0.3%
Other values (25)	260	2.6%

Most occurring characters

Value	Count	Frequency (%)
T	8639	13.4%
C	8488	13.1%
N	8079	12.5%
S	6069	9.4%
A	5629	8.7%
O	4964	7.7%
E	4639	7.2%
K	4369	6.8%
R	4132	6.4%
	4090	6.3%
Other values (32)	5590	8.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	64688	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	8639	13.4%
C	8488	13.1%
N	8079	12.5%
S	6069	9.4%
A	5629	8.7%
O	4964	7.7%
E	4639	7.2%
K	4369	6.8%
R	4132	6.4%
	4090	6.3%
Other values (32)	5590	8.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	64688	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	8639	13.4%
C	8488	13.1%
N	8079	12.5%
S	6069	9.4%
A	5629	8.7%
O	4964	7.7%
E	4639	7.2%
K	4369	6.8%
R	4132	6.4%
	4090	6.3%
Other values (32)	5590	8.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	64688	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	8639	13.4%
C	8488	13.1%
N	8079	12.5%
S	6069	9.4%
A	5629	8.7%
O	4964	7.7%
E	4639	7.2%
K	4369	6.8%
R	4132	6.4%
	4090	6.3%
Other values (32)	5590	8.6%

BookingID
Text

Distinct	6875
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	18
Median length	12
Mean length	12.722093
Min length	12

Characters and Unicode

Total characters	87528
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6871 ?
Unique (%)	99.9%

Sample

1st row	MVCV0000927/082021
2nd row	VCV00014271/082021
3rd row	VCV00014382/082021
4th row	VCV00014743/082021
5th row	VCV00014744/082021

Value	Count	Frequency (%)
mvcv0000798/082021	3	< 0.1%
mvcv0000759/082021	2	< 0.1%
vcv00014072/082021	2	< 0.1%
aeibk1902026	2	< 0.1%
vcv00014554/082021	1	< 0.1%
vcv00014743/082021	1	< 0.1%
vcv00014744/082021	1	< 0.1%
vcv00014749/082021	1	< 0.1%
vcv00014750/082021	1	< 0.1%
vcv00014812/082021	1	< 0.1%
Other values (6865)	6865	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	11595	13.2%
2	9561	10.9%
1	6531	7.5%
K	6052	6.9%
B	6052	6.9%
E	4511	5.2%
A	4511	5.2%
I	4511	5.2%
9	4121	4.7%
4	3984	4.6%
Other values (14)	26099	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87528	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	11595	13.2%
2	9561	10.9%
1	6531	7.5%
K	6052	6.9%
B	6052	6.9%
E	4511	5.2%
A	4511	5.2%
I	4511	5.2%
9	4121	4.7%
4	3984	4.6%
Other values (14)	26099	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87528	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	11595	13.2%
2	9561	10.9%
1	6531	7.5%
K	6052	6.9%
B	6052	6.9%
E	4511	5.2%
A	4511	5.2%
I	4511	5.2%
9	4121	4.7%
4	3984	4.6%
Other values (14)	26099	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87528	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	11595	13.2%
2	9561	10.9%
1	6531	7.5%
K	6052	6.9%
B	6052	6.9%
E	4511	5.2%
A	4511	5.2%
I	4511	5.2%
9	4121	4.7%
4	3984	4.6%
Other values (14)	26099	29.8%

Market/Regular
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Regular	6811
Market	69

Length

Max length	7
Median length	7
Mean length	6.9899709
Min length	6

Characters and Unicode

Total characters	48091
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Market
2nd row	Regular
3rd row	Regular
4th row	Regular
5th row	Regular

Common Values

Value	Count	Frequency (%)
Regular	6811	99.0%
Market	69	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
regular	6811	99.0%
market	69	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	6880	14.3%
a	6880	14.3%
r	6880	14.3%
R	6811	14.2%
g	6811	14.2%
u	6811	14.2%
l	6811	14.2%
M	69	0.1%
k	69	0.1%
t	69	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	48091	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6880	14.3%
a	6880	14.3%
r	6880	14.3%
R	6811	14.2%
g	6811	14.2%
u	6811	14.2%
l	6811	14.2%
M	69	0.1%
k	69	0.1%
t	69	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	48091	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6880	14.3%
a	6880	14.3%
r	6880	14.3%
R	6811	14.2%
g	6811	14.2%
u	6811	14.2%
l	6811	14.2%
M	69	0.1%
k	69	0.1%
t	69	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	48091	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6880	14.3%
a	6880	14.3%
r	6880	14.3%
R	6811	14.2%
g	6811	14.2%
u	6811	14.2%
l	6811	14.2%
M	69	0.1%
k	69	0.1%
t	69	0.1%

BookingID_Date
Date

Distinct	6005
Distinct (%)	87.3%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Minimum	2019-03-18 12:19:22
Maximum	2020-12-03 13:10:21

Histogram

Histogram with fixed size bins (bins=50)

vehicle_no
Text

Distinct	2325
Distinct (%)	33.8%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	12
Median length	9
Mean length	9.4103198
Min length	7

Characters and Unicode

Total characters	64743
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1381 ?
Unique (%)	20.1%

Sample

1st row	KA590408
2nd row	TN30BC5917
3rd row	TN22AR2748
4th row	TN28AQ0781
5th row	TN68F1722

Value	Count	Frequency (%)
ts15uc9341	37	0.5%
ka01af0114	31	0.4%
ka21a5090	31	0.4%
ka21a3643	30	0.4%
ts15ud3698	29	0.4%
ka029324	28	0.4%
tn04ac4746	27	0.4%
ka219934	27	0.4%
ts15ud5174	26	0.4%
ts15ud3697	26	0.4%
Other values (2337)	6624	95.8%

Most occurring characters

Value	Count	Frequency (%)
1	6294	9.7%
0	4759	7.4%
4	4118	6.4%
3	4052	6.3%
5	4049	6.3%
2	3811	5.9%
8	3740	5.8%
9	3582	5.5%
7	3524	5.4%
6	3343	5.2%
Other values (36)	23471	36.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	64743	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	6294	9.7%
0	4759	7.4%
4	4118	6.4%
3	4052	6.3%
5	4049	6.3%
2	3811	5.9%
8	3740	5.8%
9	3582	5.5%
7	3524	5.4%
6	3343	5.2%
Other values (36)	23471	36.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	64743	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	6294	9.7%
0	4759	7.4%
4	4118	6.4%
3	4052	6.3%
5	4049	6.3%
2	3811	5.9%
8	3740	5.8%
9	3582	5.5%
7	3524	5.4%
6	3343	5.2%
Other values (36)	23471	36.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	64743	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	6294	9.7%
0	4759	7.4%
4	4118	6.4%
3	4052	6.3%
5	4049	6.3%
2	3811	5.9%
8	3740	5.8%
9	3582	5.5%
7	3524	5.4%
6	3343	5.2%
Other values (36)	23471	36.3%

Origin_Location
Text

Distinct	180
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	56
Median length	46
Mean length	33.112355
Min length	16

Characters and Unicode

Total characters	227813
Distinct characters	61
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	41 ?
Unique (%)	0.6%

Sample

1st row	TVSLSL-PUZHAL-HUB,CHENNAI,TAMIL NADU
2nd row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
3rd row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY
4th row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
5th row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY

Value	Count	Frequency (%)
nadu	1669	6.4%
tamil	1181	4.5%
karnataka	931	3.6%
bangalore	927	3.6%
india	877	3.4%
maharashtra	701	2.7%
mugabala	572	2.2%
rural	572	2.2%
kanchipuram	557	2.1%
gujarat	476	1.8%
Other values (324)	17537	67.5%

Most occurring characters

Value	Count	Frequency (%)
a	35802	15.7%
	19120	8.4%
,	13349	5.9%
r	13281	5.8%
n	8867	3.9%
l	8748	3.8%
u	7961	3.5%
i	7801	3.4%
e	7344	3.2%
h	7316	3.2%
Other values (51)	98224	43.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	227813	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	35802	15.7%
	19120	8.4%
,	13349	5.9%
r	13281	5.8%
n	8867	3.9%
l	8748	3.8%
u	7961	3.5%
i	7801	3.4%
e	7344	3.2%
h	7316	3.2%
Other values (51)	98224	43.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	227813	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	35802	15.7%
	19120	8.4%
,	13349	5.9%
r	13281	5.8%
n	8867	3.9%
l	8748	3.8%
u	7961	3.5%
i	7801	3.4%
e	7344	3.2%
h	7316	3.2%
Other values (51)	98224	43.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	227813	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	35802	15.7%
	19120	8.4%
,	13349	5.9%
r	13281	5.8%
n	8867	3.9%
l	8748	3.8%
u	7961	3.5%
i	7801	3.4%
e	7344	3.2%
h	7316	3.2%
Other values (51)	98224	43.1%

Destination_Location
Text

Distinct	520
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	58
Median length	49
Mean length	34.14157
Min length	10

Characters and Unicode

Total characters	234894
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	175 ?
Unique (%)	2.5%

Sample

1st row	ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA
2nd row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
3rd row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY
4th row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
5th row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY

Value	Count	Frequency (%)
nadu	1719	6.5%
tamil	1238	4.7%
bangalore	1047	3.9%
india	878	3.3%
karnataka	857	3.2%
kanchipuram	648	2.4%
west	595	2.2%
gujarat	499	1.9%
haryana	496	1.9%
delhi	462	1.7%
Other values (834)	18073	68.2%

Most occurring characters

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Org_lat_lon
Text

Distinct	173
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	37
Median length	36
Mean length	25.484448
Min length	15

Characters and Unicode

Total characters	175333
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	40 ?
Unique (%)	0.6%

Sample

1st row	13.1550,80.1960
2nd row	12.8390,79.9540
3rd row	11.8710,79.7390
4th row	12.8390,79.9540
5th row	11.8720,79.6320

Value	Count	Frequency (%)
16.560192249175344,80.792293091599547	1189	17.3%
18.750621,73.87719	428	6.2%
12.0001,79.74839949999999	409	5.9%
26.192290403509681,91.751276775362513	380	5.5%
12.8390,79.9540	342	5.0%
28.373519,76.835337	254	3.7%
22.961777,72.094219	217	3.2%
23.525267916088961,87.264424348570884	214	3.1%
13.007503209603689,77.665098855934886	199	2.9%
12.992699792116747,77.803841411108593	161	2.3%
Other values (163)	3087	44.9%

Most occurring characters

Value	Count	Frequency (%)
9	22674	12.9%
7	19682	11.2%
1	18676	10.7%
2	17607	10.0%
.	13760	7.8%
0	13673	7.8%
8	13167	7.5%
5	13038	7.4%
3	12428	7.1%
6	12024	6.9%
Other values (2)	18604	10.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	175333	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	22674	12.9%
7	19682	11.2%
1	18676	10.7%
2	17607	10.0%
.	13760	7.8%
0	13673	7.8%
8	13167	7.5%
5	13038	7.4%
3	12428	7.1%
6	12024	6.9%
Other values (2)	18604	10.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	175333	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	22674	12.9%
7	19682	11.2%
1	18676	10.7%
2	17607	10.0%
.	13760	7.8%
0	13673	7.8%
8	13167	7.5%
5	13038	7.4%
3	12428	7.1%
6	12024	6.9%
Other values (2)	18604	10.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	175333	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	22674	12.9%
7	19682	11.2%
1	18676	10.7%
2	17607	10.0%
.	13760	7.8%
0	13673	7.8%
8	13167	7.5%
5	13038	7.4%
3	12428	7.1%
6	12024	6.9%
Other values (2)	18604	10.6%

Des_lat_lon
Text

Distinct	522
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	37
Median length	36
Mean length	22.238663
Min length	14

Characters and Unicode

Total characters	153002
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	178 ?
Unique (%)	2.6%

Sample

1st row	12.7400,77.8200
2nd row	12.8390,79.9540
3rd row	11.8710,79.7390
4th row	12.8390,79.9540
5th row	11.8720,79.6320

Value	Count	Frequency (%)
12.8390,79.9540	342	5.0%
12.786517,79.975221	252	3.7%
13.199089183304451,77.708554234959038	227	3.3%
12.930429,79.931163	209	3.0%
22.961777,72.094219	182	2.6%
18.750621,73.87719	180	2.6%
28.373519,76.835337	171	2.5%
22.95210237429815,88.457014796076109	124	1.8%
12.843107191355518,77.5942828776749	123	1.8%
12.777874729699617,77.642275537347089	114	1.7%
Other values (512)	4956	72.0%

Most occurring characters

Value	Count	Frequency (%)
7	19782	12.9%
2	16536	10.8%
9	14877	9.7%
1	14763	9.6%
.	13760	9.0%
8	13191	8.6%
3	11759	7.7%
0	10936	7.1%
6	10426	6.8%
5	10093	6.6%
Other values (2)	16879	11.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153002	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	19782	12.9%
2	16536	10.8%
9	14877	9.7%
1	14763	9.6%
.	13760	9.0%
8	13191	8.6%
3	11759	7.7%
0	10936	7.1%
6	10426	6.8%
5	10093	6.6%
Other values (2)	16879	11.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153002	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	19782	12.9%
2	16536	10.8%
9	14877	9.7%
1	14763	9.6%
.	13760	9.0%
8	13191	8.6%
3	11759	7.7%
0	10936	7.1%
6	10426	6.8%
5	10093	6.6%
Other values (2)	16879	11.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153002	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	19782	12.9%
2	16536	10.8%
9	14877	9.7%
1	14763	9.6%
.	13760	9.0%
8	13191	8.6%
3	11759	7.7%
0	10936	7.1%
6	10426	6.8%
5	10093	6.6%
Other values (2)	16879	11.0%

Data_Ping_time
Date

MISSING

Distinct	3756
Distinct (%)	63.4%
Missing	953
Missing (%)	13.9%
Memory size	53.9 KiB

Minimum	2019-06-07 18:25:10
Maximum	2020-08-28 12:40:31

Histogram

Histogram with fixed size bins (bins=50)

Planned_ETA
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Current_Location
Text

MISSING

Distinct	2567
Distinct (%)	43.4%
Missing	964
Missing (%)	14.0%
Memory size	53.9 KiB

Length

Max length	241
Median length	138
Mean length	67.408384
Min length	11

Characters and Unicode

Total characters	398788
Distinct characters	79
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1745 ?
Unique (%)	29.5%

Sample

1st row	Vaniyambadi Rd, Valayambattu, Tamil Nadu 635752, India
2nd row	Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India
3rd row	570, National Hwy 48, Shenoy Nagar, Chennai, Tamil Nadu 600030, India
4th row	Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India
5th row	Melmaruvathur, Tamil Nadu 603319, India

Value	Count	Frequency (%)
india	5927	10.7%
rd	1843	3.3%
road	1786	3.2%
tamil	1614	2.9%
nadu	1614	2.9%
unnamed	1455	2.6%
	933	1.7%
nagar	867	1.6%
karnataka	787	1.4%
industrial	782	1.4%
Other values (5625)	37564	68.1%

Most occurring characters

Value	Count	Frequency (%)
a	53279	13.4%
	49256	12.4%
,	24109	6.0%
n	20265	5.1%
d	19957	5.0%
i	19051	4.8%
r	17828	4.5%
l	11543	2.9%
e	11328	2.8%
t	10720	2.7%
Other values (69)	161452	40.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	398788	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	53279	13.4%
	49256	12.4%
,	24109	6.0%
n	20265	5.1%
d	19957	5.0%
i	19051	4.8%
r	17828	4.5%
l	11543	2.9%
e	11328	2.8%
t	10720	2.7%
Other values (69)	161452	40.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	398788	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	53279	13.4%
	49256	12.4%
,	24109	6.0%
n	20265	5.1%
d	19957	5.0%
i	19051	4.8%
r	17828	4.5%
l	11543	2.9%
e	11328	2.8%
t	10720	2.7%
Other values (69)	161452	40.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	398788	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	53279	13.4%
	49256	12.4%
,	24109	6.0%
n	20265	5.1%
d	19957	5.0%
i	19051	4.8%
r	17828	4.5%
l	11543	2.9%
e	11328	2.8%
t	10720	2.7%
Other values (69)	161452	40.5%

DestinationLocation
Text

Distinct	520
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	58
Median length	49
Mean length	34.14157
Min length	10

Characters and Unicode

Total characters	234894
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	175 ?
Unique (%)	2.5%

Sample

1st row	ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA
2nd row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
3rd row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY
4th row	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU
5th row	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY

Value	Count	Frequency (%)
nadu	1719	6.5%
tamil	1238	4.7%
bangalore	1047	3.9%
india	878	3.3%
karnataka	857	3.2%
kanchipuram	648	2.4%
west	595	2.2%
gujarat	499	1.9%
haryana	496	1.9%
delhi	462	1.7%
Other values (834)	18073	68.2%

Most occurring characters

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	234894	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	35110	14.9%
	19632	8.4%
r	13936	5.9%
,	13768	5.9%
n	11253	4.8%
i	9260	3.9%
l	7698	3.3%
h	7694	3.3%
e	7394	3.1%
d	7373	3.1%
Other values (55)	101776	43.3%

actual_eta
Unsupported

REJECTED UNSUPPORTED

Missing	37
Missing (%)	0.5%
Memory size	53.9 KiB

Curr_lat
Real number (ℝ)

MISSING

Distinct	4139
Distinct (%)	69.8%
Missing	953
Missing (%)	13.9%
Infinite	0
Infinite (%)	0.0%
Mean	18.679995

Minimum	8.16679
Maximum	32.367928
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	53.9 KiB

Quantile statistics

Minimum	8.16679
5-th percentile	12.485942
Q1	12.871868
median	17.470922
Q3	23.202009
95-th percentile	28.536316
Maximum	32.367928
Range	24.201138
Interquartile range (IQR)	10.330141

Descriptive statistics

Standard deviation	6.0755609
Coefficient of variation (CV)	0.32524425
Kurtosis	-1.3083293
Mean	18.679995
Median Absolute Deviation (MAD)	4.6892575
Skewness	0.40896195
Sum	110716.33
Variance	36.91244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.46342	33	0.5%
17.4709225	21	0.3%
19.032803	20	0.3%
13.166807	18	0.3%
13.19702	16	0.2%
28.20895	16	0.2%
12.781673	15	0.2%
13.1191355	14	0.2%
13.199137	13	0.2%
28.52547	13	0.2%
Other values (4129)	5748	83.5%
(Missing)	953	13.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.16679	1	< 0.1%
8.194479	1	< 0.1%
8.70089	1	< 0.1%
8.7388	1	< 0.1%
8.784697	1	< 0.1%
8.81781	1	< 0.1%
8.912319	1	< 0.1%
9.061639444	1	< 0.1%
9.369471	1	< 0.1%
9.483545	2	< 0.1%

Value	Count	Frequency (%)
32.367928	1	< 0.1%
32.3675	1	< 0.1%
31.360373	1	< 0.1%
31.360283	1	< 0.1%
31.35795222	1	< 0.1%
31.34324	1	< 0.1%
31.337187	1	< 0.1%
31.33258	1	< 0.1%
31.33047583	1	< 0.1%
31.12698194	1	< 0.1%

Curr_lon
Real number (ℝ)

MISSING

Distinct	4109
Distinct (%)	69.3%
Missing	953
Missing (%)	13.9%
Infinite	0
Infinite (%)	0.0%
Mean	78.759745

Minimum	69.657698
Maximum	95.52955
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	53.9 KiB

Quantile statistics

Minimum	69.657698
5-th percentile	72.414279
Q1	76.891857
median	77.84334
Q3	80.018999
95-th percentile	88.27194
Maximum	95.52955
Range	25.871852
Interquartile range (IQR)	3.127142

Descriptive statistics

Standard deviation	4.2163571
Coefficient of variation (CV)	0.053534417
Kurtosis	1.2433644
Mean	78.759745
Median Absolute Deviation (MAD)	2.1070778
Skewness	0.96375247
Sum	466809.01
Variance	17.777667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
78.19776	33	0.5%
78.22128306	21	0.3%
73.1012153	20	0.3%
80.29405	18	0.3%
77.71069	16	0.2%
77.30532	16	0.2%
80.01655	15	0.2%
77.8888891	14	0.2%
77.28333	13	0.2%
77.711136	13	0.2%
Other values (4099)	5748	83.5%
(Missing)	953	13.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
69.65769778	1	< 0.1%
69.8644	1	< 0.1%
70.06671	1	< 0.1%
70.098045	1	< 0.1%
70.11327	1	< 0.1%
70.5046	1	< 0.1%
70.83222639	1	< 0.1%
71.45707361	1	< 0.1%
71.97328083	1	< 0.1%
71.97397667	5	0.1%

Value	Count	Frequency (%)
95.52955	1	< 0.1%
94.94118694	1	< 0.1%
94.91118917	1	< 0.1%
94.88311	1	< 0.1%
94.45472	1	< 0.1%
94.20018	1	< 0.1%
94.19761417	1	< 0.1%
93.74356972	1	< 0.1%
92.79803	1	< 0.1%
92.79426111	1	< 0.1%

ontime
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	4332
Missing (%)	63.0%
Memory size	53.9 KiB

G	2548

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2548
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	G
2nd row	G
3rd row	G
4th row	G
5th row	G

Common Values

Value	Count	Frequency (%)
G	2548	37.0%
(Missing)	4332	63.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
g	2548	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	2548	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2548	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	2548	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2548	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	2548	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2548	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	2548	100.0%

delay
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	2538
Missing (%)	36.9%
Memory size	53.9 KiB

R	4342

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4342
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	R
2nd row	R
3rd row	R
4th row	R
5th row	R

Common Values

Value	Count	Frequency (%)
R	4342	63.1%
(Missing)	2538	36.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
r	4342	100.0%

Most occurring characters

Value	Count	Frequency (%)
R	4342	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4342	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	4342	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4342	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	4342	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4342	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	4342	100.0%

OriginLocation_Code
Unsupported

REJECTED UNSUPPORTED

Missing	3
Missing (%)	< 0.1%
Memory size	53.9 KiB

DestinationLocation_Code
Unsupported

REJECTED UNSUPPORTED

Missing	27
Missing (%)	0.4%
Memory size	53.9 KiB

trip_start_date
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

trip_end_date
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	194
Missing (%)	2.8%
Memory size	53.9 KiB

TRANSPORTATION_DISTANCE_IN_KM
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	564
Distinct (%)	9.1%
Missing	712
Missing (%)	10.3%
Infinite	0
Infinite (%)	0.0%
Mean	553.85628

Minimum	0
Maximum	2954.7
Zeros	18
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	53.9 KiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	40
median	160
Q3	900
95-th percentile	2400
Maximum	2954.7
Range	2954.7
Interquartile range (IQR)	860

Descriptive statistics

Standard deviation	758.98184
Coefficient of variation (CV)	1.3703588
Kurtosis	0.8988935
Mean	553.85628
Median Absolute Deviation (MAD)	135
Skewness	1.4730875
Sum	3416185.5
Variance	576053.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	384	5.6%
30	227	3.3%
1900	201	2.9%
40	180	2.6%
70	177	2.6%
49	143	2.1%
1290	137	2.0%
2425	132	1.9%
31	122	1.8%
1199	121	1.8%
Other values (554)	4344	63.1%
(Missing)	712	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	0.3%
3	46	0.7%
5	2	< 0.1%
7.6	5	0.1%
8.2	3	< 0.1%
9.4	16	0.2%
10	1	< 0.1%
10.2	2	< 0.1%
12	3	< 0.1%
12.8	1	< 0.1%

Value	Count	Frequency (%)
2954.7	1	< 0.1%
2898	1	< 0.1%
2884	1	< 0.1%
2800	2	< 0.1%
2750	29	0.4%
2723	2	< 0.1%
2710	1	< 0.1%
2704	1	< 0.1%
2700	33	0.5%
2681	1	< 0.1%

vehicleType
Categorical

HIGH CORRELATION MISSING

Distinct	44
Distinct (%)	0.7%
Missing	828
Missing (%)	12.0%
Memory size	53.9 KiB

40 FT 3XL Trailer 35MT	2575
32 FT Multi-Axle 14MT - HCV	957
40 FT Flat Bed Multi-Axle 27MT - Trailer	670
32 FT Single-Axle 7MT - HCV	491
28 FT Open Body 25MT	171
Other values (39)	1188

Length

Max length	47
Median length	41
Mean length	26.392102
Min length	15

Characters and Unicode

Total characters	159725
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	0.1%

Sample

1st row	32 FT Single-Axle 7MT - HCV
2nd row	32 FT Multi-Axle 14MT - HCV
3rd row	1 MT Tata Ace (Open Body)
4th row	32 FT Multi-Axle 14MT - HCV
5th row	32 FT Multi-Axle 14MT - HCV

Common Values

Value	Count	Frequency (%)
40 FT 3XL Trailer 35MT	2575	37.4%
32 FT Multi-Axle 14MT - HCV	957	13.9%
40 FT Flat Bed Multi-Axle 27MT - Trailer	670	9.7%
32 FT Single-Axle 7MT - HCV	491	7.1%
28 FT Open Body 25MT	171	2.5%
24 / 26 FT Taurus Open 21MT - HCV	158	2.3%
24 \| 26 FT Taurus Open 21MT - HCV	157	2.3%
40 FT Flat Bed Double-Axle 21MT - Trailer	152	2.2%
22 FT Taurus Open 16MT - HCV	133	1.9%
19 FT Open 7MT - MCV	111	1.6%
Other values (34)	477	6.9%
(Missing)	828	12.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ft	5977	16.7%
trailer	3404	9.5%
40	3401	9.5%
	3244	9.0%
3xl	2575	7.2%
35mt	2575	7.2%
hcv	1933	5.4%
multi-axle	1716	4.8%
32	1543	4.3%
14mt	957	2.7%
Other values (60)	8570	23.9%

Most occurring characters

Value	Count	Frequency (%)
	29880	18.7%
T	15827	9.9%
l	9045	5.7%
e	8377	5.2%
M	7940	5.0%
r	7416	4.6%
F	6804	4.3%
3	6727	4.2%
i	5862	3.7%
-	5367	3.4%
Other values (43)	56480	35.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	159725	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	29880	18.7%
T	15827	9.9%
l	9045	5.7%
e	8377	5.2%
M	7940	5.0%
r	7416	4.6%
F	6804	4.3%
3	6727	4.2%
i	5862	3.7%
-	5367	3.4%
Other values (43)	56480	35.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	159725	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	29880	18.7%
T	15827	9.9%
l	9045	5.7%
e	8377	5.2%
M	7940	5.0%
r	7416	4.6%
F	6804	4.3%
3	6727	4.2%
i	5862	3.7%
-	5367	3.4%
Other values (43)	56480	35.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	159725	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	29880	18.7%
T	15827	9.9%
l	9045	5.7%
e	8377	5.2%
M	7940	5.0%
r	7416	4.6%
F	6804	4.3%
3	6727	4.2%
i	5862	3.7%
-	5367	3.4%
Other values (43)	56480	35.4%

Minimum_kms_to_be_covered_in_a_day
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	0.1%
Missing	4060
Missing (%)	59.0%
Memory size	53.9 KiB

250.0	2529
275.0	267
0.0	24

Length

Max length	5
Median length	5
Mean length	4.9829787
Min length	3

Characters and Unicode

Total characters	14052
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	250.0
2nd row	250.0
3rd row	250.0
4th row	250.0
5th row	250.0

Common Values

Value	Count	Frequency (%)
250.0	2529	36.8%
275.0	267	3.9%
0.0	24	0.3%
(Missing)	4060	59.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
250.0	2529	89.7%
275.0	267	9.5%
0.0	24	0.9%

Most occurring characters

Value	Count	Frequency (%)
0	5373	38.2%
.	2820	20.1%
2	2796	19.9%
5	2796	19.9%
7	267	1.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14052	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	5373	38.2%
.	2820	20.1%
2	2796	19.9%
5	2796	19.9%
7	267	1.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14052	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	5373	38.2%
.	2820	20.1%
2	2796	19.9%
5	2796	19.9%
7	267	1.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14052	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	5373	38.2%
.	2820	20.1%
2	2796	19.9%
5	2796	19.9%
7	267	1.9%

Driver_Name
Text

MISSING

Distinct	1355
Distinct (%)	39.3%
Missing	3429
Missing (%)	49.8%
Memory size	53.9 KiB

Length

Max length	45
Median length	20
Mean length	10.064039
Min length	2

Characters and Unicode

Total characters	34731
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	800 ?
Unique (%)	23.2%

Sample

1st row	RAMESH
2nd row	GIRI
3rd row	RAVI
4th row	TAMIL
5th row	GANESH

Value	Count	Frequency (%)
kumar	353	6.0%
singh	175	3.0%
khan	169	2.9%
k	83	1.4%
yadav	76	1.3%
s	66	1.1%
manu	64	1.1%
n	63	1.1%
r	59	1.0%
m	58	1.0%
Other values (1285)	4712	80.2%

Most occurring characters

Value	Count	Frequency (%)
A	5204	15.0%
	2485	7.2%
R	2116	6.1%
N	2021	5.8%
S	1781	5.1%
M	1684	4.8%
H	1601	4.6%
I	1546	4.5%
a	1443	4.2%
K	1432	4.1%
Other values (45)	13418	38.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34731	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	5204	15.0%
	2485	7.2%
R	2116	6.1%
N	2021	5.8%
S	1781	5.1%
M	1684	4.8%
H	1601	4.6%
I	1546	4.5%
a	1443	4.2%
K	1432	4.1%
Other values (45)	13418	38.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34731	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	5204	15.0%
	2485	7.2%
R	2116	6.1%
N	2021	5.8%
S	1781	5.1%
M	1684	4.8%
H	1601	4.6%
I	1546	4.5%
a	1443	4.2%
K	1432	4.1%
Other values (45)	13418	38.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34731	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	5204	15.0%
	2485	7.2%
R	2116	6.1%
N	2021	5.8%
S	1781	5.1%
M	1684	4.8%
H	1601	4.6%
I	1546	4.5%
a	1443	4.2%
K	1432	4.1%
Other values (45)	13418	38.6%

Driver_MobileNo
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1273
Distinct (%)	47.3%
Missing	4189
Missing (%)	60.9%
Infinite	0
Infinite (%)	0.0%
Mean	8.5989813 × 10⁹

Minimum	6.0005463 × 10⁹
Maximum	1 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	53.9 KiB

Quantile statistics

Minimum	6.0005463 × 10⁹
5-th percentile	6.3837783 × 10⁹
Q1	7.6515046 × 10⁹
median	8.9307619 × 10⁹
Q3	9.6349814 × 10⁹
95-th percentile	9.9521734 × 10⁹
Maximum	1 × 10¹⁰
Range	3.9994537 × 10⁹
Interquartile range (IQR)	1.9834768 × 10⁹

Descriptive statistics

Standard deviation	1.1316687 × 10⁹
Coefficient of variation (CV)	0.13160498
Kurtosis	-1.019947
Mean	8.5989813 × 10⁹
Median Absolute Deviation (MAD)	8.6022544 × 10⁸
Skewness	-0.5050876
Sum	2.3139859 × 10¹³
Variance	1.2806742 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9952349318	28	0.4%
7868857313	18	0.3%
9600691019	18	0.3%
7082423070	18	0.3%
7082423058	17	0.2%
9944446299	17	0.2%
9952173355	16	0.2%
9688429909	14	0.2%
8015761413	14	0.2%
8295883296	14	0.2%
Other values (1263)	2517	36.6%
(Missing)	4189	60.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6000546262	3	< 0.1%
6006291329	1	< 0.1%
6006450076	2	< 0.1%
6201157407	2	< 0.1%
6201982709	1	< 0.1%
6201994678	2	< 0.1%
6202125568	2	< 0.1%
6203975611	2	< 0.1%
6204355364	1	< 0.1%
6204621632	1	< 0.1%

Value	Count	Frequency (%)
9999999999	7	0.1%
9999681295	3	< 0.1%
9999031538	2	< 0.1%
9998843103	1	< 0.1%
9997623277	1	< 0.1%
9997471510	1	< 0.1%
9997295833	2	< 0.1%
9996036863	1	< 0.1%
9994900412	1	< 0.1%
9994798323	2	< 0.1%

customerID
Categorical

HIGH CORRELATION IMBALANCE

Distinct	39
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

LTLEXMUM40	4092
FILEXCHE19	657
DMREXCHEUX	588
ALLEXCHE45	251
LUTGCCHE06	222
Other values (34)	1070

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	68800
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	ALLEXCHE45
2nd row	DMREXCHEUX
3rd row	LUTGCCHE06
4th row	DMREXCHEUX
5th row	LUTGCCHE06

Common Values

Value	Count	Frequency (%)
LTLEXMUM40	4092	59.5%
FILEXCHE19	657	9.5%
DMREXCHEUX	588	8.5%
ALLEXCHE45	251	3.6%
LUTGCCHE06	222	3.2%
ERCEXPUNTG	211	3.1%
BILGCCHE02	161	2.3%
TMCGCCHE05	117	1.7%
OTIEXHOSJM	108	1.6%
WENEXBAN18	78	1.1%
Other values (29)	395	5.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ltlexmum40	4092	59.5%
filexche19	657	9.5%
dmrexcheux	588	8.5%
allexche45	251	3.6%
lutgcche06	222	3.2%
ercexpuntg	211	3.1%
bilgcche02	161	2.3%
tmcgcche05	117	1.7%
otiexhosjm	108	1.6%
wenexban18	78	1.1%
Other values (29)	395	5.7%

Most occurring characters

Value	Count	Frequency (%)
L	9780	14.2%
M	9144	13.3%
E	8789	12.8%
X	6906	10.0%
U	5347	7.8%
T	4957	7.2%
0	4657	6.8%
4	4429	6.4%
C	3067	4.5%
H	2287	3.3%
Other values (25)	9437	13.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	68800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	9780	14.2%
M	9144	13.3%
E	8789	12.8%
X	6906	10.0%
U	5347	7.8%
T	4957	7.2%
0	4657	6.8%
4	4429	6.4%
C	3067	4.5%
H	2287	3.3%
Other values (25)	9437	13.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	68800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	9780	14.2%
M	9144	13.3%
E	8789	12.8%
X	6906	10.0%
U	5347	7.8%
T	4957	7.2%
0	4657	6.8%
4	4429	6.4%
C	3067	4.5%
H	2287	3.3%
Other values (25)	9437	13.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	68800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	9780	14.2%
M	9144	13.3%
E	8789	12.8%
X	6906	10.0%
U	5347	7.8%
T	4957	7.2%
0	4657	6.8%
4	4429	6.4%
C	3067	4.5%
H	2287	3.3%
Other values (25)	9437	13.7%

customerNameCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	39
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Larsen & toubro limited	4092
Ford india private limited	657
Daimler india commercial vehicles pvt lt	588
Lucas tvs ltd	222
Ashok leyland limited	211
Other values (34)	1110

Length

Max length	40
Median length	23
Mean length	24.977762
Min length	13

Characters and Unicode

Total characters	171847
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	Ashok leyland limited
2nd row	Daimler india commercial vehicles pvt lt
3rd row	Lucas tvs ltd
4th row	Daimler india commercial vehicles pvt lt
5th row	Lucas tvs ltd

Common Values

Value	Count	Frequency (%)
Larsen & toubro limited	4092	59.5%
Ford india private limited	657	9.5%
Daimler india commercial vehicles pvt lt	588	8.5%
Lucas tvs ltd	222	3.2%
Ashok leyland limited	211	3.1%
Ericsson india private limited	211	3.1%
Brakes india private ltd	161	2.3%
Tvs motor company limited	117	1.7%
Otis elevator company (india) ltd	108	1.6%
Wipro enterprises pvt ltd	78	1.1%
Other values (29)	435	6.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
limited	5496	19.4%
	4116	14.5%
larsen	4092	14.4%
toubro	4092	14.4%
india	1867	6.6%
private	1126	4.0%
ltd	782	2.8%
pvt	743	2.6%
ford	657	2.3%
daimler	588	2.1%
Other values (69)	4791	16.9%

Most occurring characters

Value	Count	Frequency (%)
	21470	12.5%
i	18397	10.7%
e	14543	8.5%
t	13890	8.1%
r	12472	7.3%
o	11103	6.5%
a	9616	5.6%
l	9335	5.4%
d	9100	5.3%
m	7886	4.6%
Other values (39)	44035	25.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	171847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	21470	12.5%
i	18397	10.7%
e	14543	8.5%
t	13890	8.1%
r	12472	7.3%
o	11103	6.5%
a	9616	5.6%
l	9335	5.4%
d	9100	5.3%
m	7886	4.6%
Other values (39)	44035	25.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	171847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	21470	12.5%
i	18397	10.7%
e	14543	8.5%
t	13890	8.1%
r	12472	7.3%
o	11103	6.5%
a	9616	5.6%
l	9335	5.4%
d	9100	5.3%
m	7886	4.6%
Other values (39)	44035	25.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	171847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	21470	12.5%
i	18397	10.7%
e	14543	8.5%
t	13890	8.1%
r	12472	7.3%
o	11103	6.5%
a	9616	5.6%
l	9335	5.4%
d	9100	5.3%
m	7886	4.6%
Other values (39)	44035	25.6%

supplierID
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

supplierNameCode
Text

Distinct	309
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	49
Median length	43
Mean length	20.548692
Min length	3

Characters and Unicode

Total characters	141375
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	100 ?
Unique (%)	1.5%

Sample

1st row	VIJAY TRANSPORT
2nd row	VJ LOGISTICS
3rd row	G.S. TRANSPORT
4th row	ARVINTH TRANSPORT
5th row	SR TRANSPORTS

Value	Count	Frequency (%)
logistics	1208	6.0%
transport	1207	6.0%
private	955	4.8%
transports	877	4.4%
unknown	742	3.7%
a	708	3.5%
limited	705	3.5%
carriers	586	2.9%
s	544	2.7%
sunita	497	2.5%
Other values (424)	12062	60.0%

Most occurring characters

Value	Count	Frequency (%)
R	14575	10.3%
	13473	9.5%
A	13018	9.2%
T	11401	8.1%
S	10820	7.7%
I	9178	6.5%
N	6840	4.8%
E	6426	4.5%
P	4880	3.5%
O	4607	3.3%
Other values (47)	46157	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	141375	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	14575	10.3%
	13473	9.5%
A	13018	9.2%
T	11401	8.1%
S	10820	7.7%
I	9178	6.5%
N	6840	4.8%
E	6426	4.5%
P	4880	3.5%
O	4607	3.3%
Other values (47)	46157	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	141375	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	14575	10.3%
	13473	9.5%
A	13018	9.2%
T	11401	8.1%
S	10820	7.7%
I	9178	6.5%
N	6840	4.8%
E	6426	4.5%
P	4880	3.5%
O	4607	3.3%
Other values (47)	46157	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	141375	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	14575	10.3%
	13473	9.5%
A	13018	9.2%
T	11401	8.1%
S	10820	7.7%
I	9178	6.5%
N	6840	4.8%
E	6426	4.5%
P	4880	3.5%
O	4607	3.3%
Other values (47)	46157	32.6%

Material Shipped
Text

Distinct	1407
Distinct (%)	20.5%
Missing	0
Missing (%)	0.0%
Memory size	53.9 KiB

Length

Max length	40
Median length	35
Mean length	17.204506
Min length	3

Characters and Unicode

Total characters	118367
Distinct characters	77
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	652 ?
Unique (%)	9.5%

Sample

1st row	BRACKET / GRAB HANDLE
2nd row	ZB MODEL PLATE / 3143
3rd row	LETTERING / FUSO
4th row	LU STRUT RA / RADIUS ROD
5th row	WISHBONE / V ROD/HDT

Value	Count	Frequency (%)
parts	1684	8.3%
auto	1516	7.4%
	1093	5.4%
starter	555	2.7%
empty	515	2.5%
12v	441	2.2%
assy	426	2.1%
motor	396	1.9%
lu	307	1.5%
trays	266	1.3%
Other values (1572)	13200	64.7%

Most occurring characters

Value	Count	Frequency (%)
	13808	11.7%
A	9938	8.4%
T	9741	8.2%
R	9002	7.6%
S	7645	6.5%
E	7307	6.2%
O	6192	5.2%
P	4416	3.7%
L	4383	3.7%
I	4124	3.5%
Other values (67)	41811	35.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	118367	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	13808	11.7%
A	9938	8.4%
T	9741	8.2%
R	9002	7.6%
S	7645	6.5%
E	7307	6.2%
O	6192	5.2%
P	4416	3.7%
L	4383	3.7%
I	4124	3.5%
Other values (67)	41811	35.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	118367	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	13808	11.7%
A	9938	8.4%
T	9741	8.2%
R	9002	7.6%
S	7645	6.5%
E	7307	6.2%
O	6192	5.2%
P	4416	3.7%
L	4383	3.7%
I	4124	3.5%
Other values (67)	41811	35.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	118367	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	13808	11.7%
A	9938	8.4%
T	9741	8.2%
R	9002	7.6%
S	7645	6.5%
E	7307	6.2%
O	6192	5.2%
P	4416	3.7%
L	4383	3.7%
I	4124	3.5%
Other values (67)	41811	35.3%

Auto

Heatmap
Table

	Curr_lat	Curr_lon	Driver_MobileNo	GpsProvider	Market/Regular	Minimum_kms_to_be_covered_in_a_day	TRANSPORTATION_DISTANCE_IN_KM	customerID	customerNameCode	vehicleType
Curr_lat	1.000	-0.240	-0.121	0.222	0.119	0.158	0.023	0.295	0.294	0.231
Curr_lon	-0.240	1.000	0.048	0.185	0.062	0.125	0.013	0.337	0.336	0.317
Driver_MobileNo	-0.121	0.048	1.000	0.282	1.000	0.000	-0.031	0.192	0.191	0.189
GpsProvider	0.222	0.185	0.282	1.000	0.000	0.289	0.334	0.433	0.431	0.211
Market/Regular	0.119	0.062	1.000	0.000	1.000	1.000	0.206	0.410	0.425	1.000
Minimum_kms_to_be_covered_in_a_day	0.158	0.125	0.000	0.289	1.000	1.000	0.361	1.000	1.000	0.707
TRANSPORTATION_DISTANCE_IN_KM	0.023	0.013	-0.031	0.334	0.206	0.361	1.000	0.505	0.504	0.425
customerID	0.295	0.337	0.192	0.433	0.410	1.000	0.505	1.000	0.987	0.493
customerNameCode	0.294	0.336	0.191	0.431	0.425	1.000	0.504	0.987	1.000	0.503
vehicleType	0.231	0.317	0.189	0.211	1.000	0.707	0.425	0.493	0.503	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	GpsProvider	BookingID	Market/Regular	BookingID_Date	vehicle_no	Origin_Location	Destination_Location	Org_lat_lon	Des_lat_lon	Data_Ping_time	Planned_ETA	Current_Location	DestinationLocation	actual_eta	Curr_lat	Curr_lon	ontime	delay	OriginLocation_Code	DestinationLocation_Code	trip_start_date	trip_end_date	TRANSPORTATION_DISTANCE_IN_KM	vehicleType	Minimum_kms_to_be_covered_in_a_day	Driver_Name	Driver_MobileNo	customerID	customerNameCode	supplierID	supplierNameCode	Material Shipped
0	CONSENT TRACK	MVCV0000927/082021	Market	2020-08-17 14:59:01.000	KA590408	TVSLSL-PUZHAL-HUB,CHENNAI,TAMIL NADU	ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA	13.1550,80.1960	12.7400,77.8200	2020-08-24 00:05:09	2020-08-21 18:59:01	Vaniyambadi Rd, Valayambattu, Tamil Nadu 635752, India	ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA	2020-08-28 14:38:04.447000	12.663500	78.649870	NaN	R	CHEPUZTVSHUA1	HOSHOSALLCCA2	2020-08-17 14:59:01	NaN	320.0	NaN	NaN	NaN	NaN	ALLEXCHE45	Ashok leyland limited	VIJEXHOSR7	VIJAY TRANSPORT	BRACKET / GRAB HANDLE
1	VAMOSYS	VCV00014271/082021	Regular	2020-08-27 16:22:22.827	TN30BC5917	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:28	2020-08-31 20:22:22.827000	Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 12:46:17.007000	12.836757	79.954428	G	NaN	CHEORADMRCCB1	CHEMATDMROPA7	2020-08-27 16:21:52	NaN	103.0	NaN	NaN	RAMESH	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	VJLEXSHE09	VJ LOGISTICS	ZB MODEL PLATE / 3143
2	CONSENT TRACK	VCV00014382/082021	Regular	2020-08-27 17:59:24.987	TN22AR2748	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	11.8710,79.7390	11.8710,79.7390	2020-08-28 09:05:09	2020-08-31 21:59:24.987000	570, National Hwy 48, Shenoy Nagar, Chennai, Tamil Nadu 600030, India	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	2020-08-28 16:03:30.793000	13.073956	80.225780	G	NaN	CHEPONLUTCCA4	CHEPONLUTCCA4	2020-08-27 17:57:04	NaN	300.0	NaN	NaN	GIRI	NaN	LUTGCCHE06	Lucas tvs ltd	GSTEXLAK1Q	G.S. TRANSPORT	LETTERING / FUSO
3	VAMOSYS	VCV00014743/082021	Regular	2020-08-28 00:48:24.503	TN28AQ0781	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:31	2020-09-01 04:48:24.503000	Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 12:50:27.997000	12.836686	79.950560	G	NaN	CHEORADMRCCB1	CHEMATDMROPA7	2020-08-28 00:47:45	NaN	61.0	NaN	NaN	RAVI	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	ARVEXNAM09	ARVINTH TRANSPORT	LU STRUT RA / RADIUS ROD
4	VAMOSYS	VCV00014744/082021	Regular	2020-08-28 01:23:19.243	TN68F1722	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	11.8720,79.6320	11.8720,79.6320	2020-08-28 12:40:29	2020-09-01 05:23:19.243000	Melmaruvathur, Tamil Nadu 603319, India	LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY	2020-08-28 14:22:50.127000	12.429501	79.831556	G	NaN	CHENETLUTCCA1	CHENETLUTCCA1	2020-08-28 01:13:48	NaN	240.0	NaN	NaN	TAMIL	NaN	LUTGCCHE06	Lucas tvs ltd	SRTEXKOR96	SR TRANSPORTS	WISHBONE / V ROD/HDT
5	VAMOSYS	VCV00014749/082021	Regular	2020-08-28 02:14:22.640	TN88A4980	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:28	2020-09-01 06:14:22.640000	Ind.park Road, Nayapakkam, Tamil Nadu 602105, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 13:25:50.353000	13.017365	79.962313	G	NaN	CHEORADMRCCB1	CHEMATDMROPA7	2020-08-28 02:13:39	NaN	70.0	NaN	NaN	GANESH	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	ESWEXNAM02	ESWAR TRANSPORT	MOUNTING BRACKET / FUEL TANK
6	VAMOSYS	VCV00014750/082021	Regular	2020-08-28 02:20:27.530	TN88C8204	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:29	2020-09-01 06:20:27.530000	Rettai Kovil Bus Stop, 64, Salem - Ulundurpettai Hwy, K R Nagar, Seelanaickenpatti, Salem, Tamil Nadu 636006, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 17:38:13.480000	11.625962	78.157271	G	NaN	CHEORADMRCCB1	CHEMATDMROPA7	2020-08-28 02:19:47	NaN	931.0	NaN	NaN	SAKTHIVEL.M	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	ESWEXNAM02	ESWAR TRANSPORT	MOUNTING BRACKET / FUEL TANK
7	VAMOSYS	VCV00014812/082021	Regular	2020-08-28 09:22:31.377	TN88D4133	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:28	2020-09-01 13:22:31.377000	Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 12:49:03.727000	12.836837	79.951003	G	NaN	CHEORADMRCCB1	CHEMTADMROPA1	2020-08-28 09:21:56	NaN	20.0	NaN	NaN	SUDHAKAR	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	NSAEXNAMDZ	NAMAKKAL SRI ANJINAYA TRANSPORT	MOUNTING BRACKET / FUEL TANK
8	CONSENT TRACK	MVCV0001769/082021	Market	2020-08-28 09:38:30.000	TN23AM4662	ASHOK LEYLAND ENNORE,CHENNAI,TAMIL NADU	ASHOK LEYLAND PLANT 2-HOSUR,HOSUR,KARNATAKA	13.2150,80.3200	12.7660,77.7860	2020-08-28 09:00:06	2020-09-01 13:38:30	Mumbai Hwy, Komeswaram, Tamil Nadu 635802, India	ASHOK LEYLAND PLANT 2-HOSUR,HOSUR,KARNATAKA	2020-08-28 15:00:19.080000	12.810470	78.740460	G	NaN	CHEENNALLCCA1	HOSHOSALLCCA3	2020-08-28 09:38:30	NaN	310.0	NaN	NaN	NaN	NaN	ALLEXCHE45	Ashok leyland limited	VRLEXENN11	VINAYAKA ROADLINES	MOUNTING BRACKET / FUEL TANK
9	VAMOSYS	VCV00014665/082021	Regular	2020-08-27 22:27:54.427	TN30BC5982	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	12.8390,79.9540	12.8390,79.9540	2020-08-28 12:40:28	2020-09-01 02:27:54.427000	Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India	DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU	2020-08-28 12:46:20.717000	12.837941	79.951967	G	NaN	CHEORADMRCCB1	CHEMATDMROPA7	2020-08-27 22:27:14	NaN	103.0	NaN	NaN	SENTHIL KUMAR	NaN	DMREXCHEUX	Daimler india commercial vehicles pvt lt	VJLEXSHE09	VJ LOGISTICS	MOUNTING BRACKET / FUEL TANK

	GpsProvider	BookingID	Market/Regular	BookingID_Date	vehicle_no	Origin_Location	Destination_Location	Org_lat_lon	Des_lat_lon	Data_Ping_time	Planned_ETA	Current_Location	DestinationLocation	actual_eta	Curr_lat	Curr_lon	ontime	delay	OriginLocation_Code	DestinationLocation_Code	trip_start_date	trip_end_date	TRANSPORTATION_DISTANCE_IN_KM	vehicleType	Minimum_kms_to_be_covered_in_a_day	Driver_Name	Driver_MobileNo	customerID	customerNameCode	supplierID	supplierNameCode	Material Shipped
6870	JTECH	WDSBKTP43133	Regular	2019-03-30 14:55:15	KA01AF0114	Mugabala, Bangalore Rural, Karnataka	Kengeri, Bangalore Rural, Karnataka	12.992699792116747,77.803841411108593	12.73017358940589,77.95620203691567	2019-06-14 15:20:12	2019-03-30 17:17:00	SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India	Kengeri, Bangalore Rural, Karnataka	2019-03-30 16:32:00	12.996516	77.740759	G	NaN	VLR00777	LE005541	2019-03-30 15:35:00	2019-03-30 16:32:00	47.3	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	BSHG-VLV GID
6871	JTECH	WDSBKTP42137	Regular	2019-03-20 18:57:16	KA01AF0114	Mugabala, Bangalore Rural, Karnataka	Anekal, Bangalore, Karnataka	12.992699792116747,77.803841411108593	12.711983972934837,77.69108593367848	2019-06-14 15:20:12	2019-03-20 20:48:16	SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India	Anekal, Bangalore, Karnataka	2019-06-14 16:57:00.137000	12.996516	77.740759	NaN	R	VLR00777	LE004850	2019-03-20 18:57:16	2019-06-14 16:57:00.137000	NaN	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	SWITCH ASSEMBLY RH
6872	JTECH	WDSBKTP43018	Regular	2019-03-29 18:33:01	KA01AF8395	Mugabala, Bangalore Rural, Karnataka	Anekal, Bangalore, Karnataka	16.560192249175344,80.792293091599547	12.711983972934837,77.69108593367848	2019-06-14 15:20:12	2019-03-29 22:12:00	NH 48, Chikkabennur, Karnataka 577541, India	Anekal, Bangalore, Karnataka	2019-03-29 21:27:00	14.312477	76.246717	G	NaN	V0048673	LE004850	2019-03-29 20:21:00	2019-03-29 21:27:00	49.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	CONTROL LEVER ASSY L
6873	JTECH	WDSBKTP42532	Regular	2019-03-25 18:20:45	KA21A6239	Mugabala, Bangalore Rural, Karnataka	Chikkabidarkal, Bangalore, Karnataka	16.560192249175344,80.792293091599547	12.777874729699617,77.642275537347089	2019-06-14 15:20:12	2019-03-27 23:09:00	Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India	Chikkabidarkal, Bangalore, Karnataka	2019-03-27 22:24:00	13.024866	77.722378	G	NaN	V0048673	LE005179	2019-03-27 20:03:00	2019-03-27 22:24:00	31.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	KILL SWITCH
6874	JTECH	WDSBKTP45240	Regular	2019-04-23 12:32:42	KA21A6239	Mugabala, Bangalore Rural, Karnataka	Bangalore International Airport, Bangalore, Karnataka	16.560192249175344,80.792293091599547	13.199089183304451,77.708554234959038	2019-06-14 15:20:12	2019-04-24 15:40:00	Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India	Bangalore International Airport, Bangalore, Karnataka	2019-04-24 14:55:00	13.024866	77.722378	G	NaN	V0048673	LE005770	2019-04-24 11:40:00	2019-04-24 14:55:00	40.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	HORN NP.027
6875	JTECH	WDSBKTP42751	Regular	2019-03-27 17:25:33	KA219502	Ramamurthy Nagar, Bangalore, Karnataka	Sahakaranagar P.O, Bangalore, Karnataka	13.007503209603689,77.665098855934886	13.068901840235711,77.590655738806618	2019-06-14 15:20:12	2019-03-27 18:31:00	SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India	Sahakaranagar P.O, Bangalore, Karnataka	2019-03-27 17:46:00	12.996370	77.740616	G	NaN	V0045771	LE005870	2019-03-27 18:00:00	2019-03-27 17:46:00	12.0	25 FT Open Body 21MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	TOOL KIT SET
6876	JTECH	WDSBKTP43203	Regular	2019-03-31 15:02:34	KA01AE9163	Ramamurthy Nagar, Bangalore, Karnataka	Bangalore International Airport, Bangalore, Karnataka	13.007503209603689,77.665098855934886	13.196312912801169,77.708156925688726	2019-06-14 15:20:12	2019-03-31 20:36:00	Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India	Bangalore International Airport, Bangalore, Karnataka	2019-03-31 19:51:00	13.024788	77.722391	G	NaN	V0045771	LE005419	2019-03-31 17:30:00	2019-03-31 19:51:00	31.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	CONTROL LEVER ASSY
6877	JTECH	WDSBKTP43021	Regular	2019-03-29 18:56:26	KA01AE9163	Mugabala, Bangalore Rural, Karnataka	Anekal, Bangalore, Karnataka	16.560192249175344,80.792293091599547	12.722686,77.676518	2019-06-14 15:20:12	2019-03-30 01:38:00	Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India	Anekal, Bangalore, Karnataka	2019-03-30 00:53:00	13.024788	77.722391	G	NaN	V0048673	LE005848	2019-03-29 20:44:00	2019-03-30 00:53:00	49.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	SPARE PARTS AUTOMOBILE
6878	JTECH	WDSBKTP42685	Regular	2019-03-27 08:29:45	KA21A3643	Mugabala, Bangalore Rural, Karnataka	Anekal, Bangalore, Karnataka	16.560192249175344,80.792293091599547	12.896896847817695,77.712223056874862	2019-06-14 15:20:12	2019-03-27 17:20:00	Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India	Anekal, Bangalore, Karnataka	2019-03-27 16:35:00	13.024747	77.721823	NaN	R	V0048673	LEL04580	2019-03-27 15:29:00	2019-03-27 16:35:00	49.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	SPARE PARTS AUTOMOBILE
6879	JTECH	WDSBKTP42858	Regular	2019-03-28 17:55:17	KA51D1317	Mugabala, Bangalore Rural, Karnataka	Anekal, Bangalore, Karnataka	16.560192249175344,80.792293091599547	13.199089183304451,77.708554234959038	2019-06-14 15:20:12	2019-03-29 00:26:00	20/1, Sulthangunta, Shivaji Nagar, Bengaluru, Karnataka 560051, India	Anekal, Bangalore, Karnataka	2019-03-28 23:41:00	12.991815	77.606038	G	NaN	V0048673	LE005770	2019-03-28 20:26:00	2019-03-28 23:41:00	49.0	40 FT 3XL Trailer 35MT	NaN	NaN	NaN	LTLEXMUM40	Larsen & toubro limited	55556	A S TRANSPORTS	SPARE PARTS AUTOMOBILE

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category